Relatório de Músicas

Dataset statistics

Number of variables	17
Number of observations	2017
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	268.0 KiB
Average record size in memory	136.1 B

Variable types

Numeric	12
Categorical	5

Alerts

`song_title` has a high cardinality: 1956 distinct values	High cardinality
`artist` has a high cardinality: 1343 distinct values	High cardinality
`id` is highly correlated with `target`	High correlation
`energy` is highly correlated with `loudness`	High correlation
`loudness` is highly correlated with `energy`	High correlation
`target` is highly correlated with `id`	High correlation
`id` is highly correlated with `target`	High correlation
`acousticness` is highly correlated with `energy` and 1 other fields	High correlation
`energy` is highly correlated with `acousticness` and 1 other fields	High correlation
`loudness` is highly correlated with `acousticness` and 1 other fields	High correlation
`target` is highly correlated with `id`	High correlation
`id` is highly correlated with `target`	High correlation
`energy` is highly correlated with `loudness`	High correlation
`loudness` is highly correlated with `energy`	High correlation
`target` is highly correlated with `id`	High correlation
`id` is highly correlated with `energy` and 1 other fields	High correlation
`acousticness` is highly correlated with `energy` and 1 other fields	High correlation
`energy` is highly correlated with `id` and 2 other fields	High correlation
`loudness` is highly correlated with `acousticness` and 1 other fields	High correlation
`target` is highly correlated with `id`	High correlation
`id` is uniformly distributed	Uniform
`song_title` is uniformly distributed	Uniform
`id` has unique values	Unique
`instrumentalness` has 693 (34.4%) zeros	Zeros
`key` has 216 (10.7%) zeros	Zeros

Reproduction

Analysis started	2022-03-22 21:40:28.323864
Analysis finished	2022-03-22 21:41:09.838635
Duration	41.51 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

id
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	2017
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1008

Minimum	0
Maximum	2016
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	15.9 KiB

Quantile statistics

Minimum	0
5-th percentile	100.8
Q1	504
median	1008
Q3	1512
95-th percentile	1915.2
Maximum	2016
Range	2016
Interquartile range (IQR)	1008

Descriptive statistics

Standard deviation	582.4020662
Coefficient of variation (CV)	0.5777798275
Kurtosis	-1.2
Mean	1008
Median Absolute Deviation (MAD)	504
Skewness	0
Sum	2033136
Variance	339192.1667
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
1340	1	< 0.1%
1353	1	< 0.1%
1352	1	< 0.1%
1351	1	< 0.1%
1350	1	< 0.1%
1349	1	< 0.1%
1348	1	< 0.1%
1347	1	< 0.1%
1346	1	< 0.1%
Other values (2007)	2007	99.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
2016	1	< 0.1%
2015	1	< 0.1%
2014	1	< 0.1%
2013	1	< 0.1%
2012	1	< 0.1%
2011	1	< 0.1%
2010	1	< 0.1%
2009	1	< 0.1%
2008	1	< 0.1%
2007	1	< 0.1%

acousticness
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	1394
Distinct (%)	69.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1875900344

Minimum	2.84 × 10^-6
Maximum	0.995
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.9 KiB

Quantile statistics

Minimum	2.84 × 10^-6
5-th percentile	0.000298
Q1	0.00963
median	0.0633
Q3	0.265
95-th percentile	0.8462
Maximum	0.995
Range	0.99499716
Interquartile range (IQR)	0.25537

Descriptive statistics

Standard deviation	0.2599892598
Coefficient of variation (CV)	1.385943878
Kurtosis	1.745620963
Mean	0.1875900344
Median Absolute Deviation (MAD)	0.06141
Skewness	1.658392712
Sum	378.3690994
Variance	0.0675944152
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.119	8	0.4%
0.114	6	0.3%
0.273	6	0.3%
0.135	6	0.3%
0.16	6	0.3%
0.0107	6	0.3%
0.0117	5	0.2%
0.0193	5	0.2%
0.101	5	0.2%
0.122	5	0.2%
Other values (1384)	1959	97.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.84 × 10^-6	1	< 0.1%
4.61 × 10^-6	1	< 0.1%
4.69 × 10^-6	1	< 0.1%
5.41 × 10^-6	1	< 0.1%
7.94 × 10^-6	1	< 0.1%
8.35 × 10^-6	1	< 0.1%
8.8 × 10^-6	1	< 0.1%
9.19 × 10^-6	1	< 0.1%
1.01 × 10^-5	1	< 0.1%
1.2 × 10^-5	1	< 0.1%

Value	Count	Frequency (%)
0.995	2	0.1%
0.994	1	< 0.1%
0.993	1	< 0.1%
0.992	1	< 0.1%
0.991	1	< 0.1%
0.99	2	0.1%
0.988	1	< 0.1%
0.986	2	0.1%
0.983	1	< 0.1%
0.978	2	0.1%

danceability
Real number (ℝ_≥0)

Distinct	632
Distinct (%)	31.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.6184219137

Minimum	0.122
Maximum	0.984
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.9 KiB

Quantile statistics

Minimum	0.122
5-th percentile	0.3268
Q1	0.514
median	0.631
Q3	0.738
95-th percentile	0.858
Maximum	0.984
Range	0.862
Interquartile range (IQR)	0.224

Descriptive statistics

Standard deviation	0.1610289674
Coefficient of variation (CV)	0.2603869039
Kurtosis	-0.2075123034
Mean	0.6184219137
Median Absolute Deviation (MAD)	0.111
Skewness	-0.4196095843
Sum	1247.357
Variance	0.02593032835
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.683	12	0.6%
0.76	11	0.5%
0.704	11	0.5%
0.646	10	0.5%
0.614	10	0.5%
0.633	10	0.5%
0.688	9	0.4%
0.624	9	0.4%
0.597	9	0.4%
0.726	9	0.4%
Other values (622)	1917	95.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.122	1	< 0.1%
0.123	1	< 0.1%
0.148	1	< 0.1%
0.152	1	< 0.1%
0.156	1	< 0.1%
0.162	2	0.1%
0.164	1	< 0.1%
0.17	1	< 0.1%
0.173	2	0.1%
0.176	1	< 0.1%

Value	Count	Frequency (%)
0.984	1	< 0.1%
0.967	1	< 0.1%
0.962	1	< 0.1%
0.959	2	0.1%
0.95	1	< 0.1%
0.947	1	< 0.1%
0.944	1	< 0.1%
0.941	2	0.1%
0.937	1	< 0.1%
0.932	1	< 0.1%

duration_ms
Real number (ℝ_≥0)

Distinct	1921
Distinct (%)	95.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	246306.1973

Minimum	16042
Maximum	1004627
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.9 KiB

Quantile statistics

Minimum	16042
5-th percentile	156863.2
Q1	200015
median	229261
Q3	270333
95-th percentile	393475
Maximum	1004627
Range	988585
Interquartile range (IQR)	70318

Descriptive statistics

Standard deviation	81981.81422
Coefficient of variation (CV)	0.3328451136
Kurtosis	11.90242311
Mean	246306.1973
Median Absolute Deviation (MAD)	32907
Skewness	2.499011859
Sum	496799600
Variance	6721017863
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
192000	5	0.2%
243493	3	0.1%
206013	3	0.1%
228467	3	0.1%
240000	3	0.1%
189333	2	0.1%
252053	2	0.1%
243800	2	0.1%
199973	2	0.1%
254360	2	0.1%
Other values (1911)	1990	98.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
16042	1	< 0.1%
16588	1	< 0.1%
47547	1	< 0.1%
51547	1	< 0.1%
52006	1	< 0.1%
66762	1	< 0.1%
82293	1	< 0.1%
82893	1	< 0.1%
87705	1	< 0.1%
93267	1	< 0.1%

Value	Count	Frequency (%)
1004627	1	< 0.1%
849960	1	< 0.1%
825027	1	< 0.1%
784013	1	< 0.1%
763467	1	< 0.1%
745653	1	< 0.1%
703107	1	< 0.1%
700027	1	< 0.1%
659560	1	< 0.1%
649415	1	< 0.1%

energy
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	719
Distinct (%)	35.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.6815771443

Minimum	0.0148
Maximum	0.998
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.9 KiB

Quantile statistics

Minimum	0.0148
5-th percentile	0.2538
Q1	0.563
median	0.715
Q3	0.846
95-th percentile	0.952
Maximum	0.998
Range	0.9832
Interquartile range (IQR)	0.283

Descriptive statistics

Standard deviation	0.2102730089
Coefficient of variation (CV)	0.3085094779
Kurtosis	0.5726185439
Mean	0.6815771443
Median Absolute Deviation (MAD)	0.139
Skewness	-0.9130104652
Sum	1374.7411
Variance	0.04421473828
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.857	10	0.5%
0.657	9	0.4%
0.86	9	0.4%
0.77	9	0.4%
0.793	9	0.4%
0.811	8	0.4%
0.802	8	0.4%
0.921	8	0.4%
0.894	8	0.4%
0.664	8	0.4%
Other values (709)	1931	95.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.0148	1	< 0.1%
0.0156	1	< 0.1%
0.0161	1	< 0.1%
0.023	1	< 0.1%
0.0288	1	< 0.1%
0.0291	1	< 0.1%
0.0295	1	< 0.1%
0.0302	1	< 0.1%
0.031	1	< 0.1%
0.0347	1	< 0.1%

Value	Count	Frequency (%)
0.998	1	< 0.1%
0.997	1	< 0.1%
0.994	1	< 0.1%
0.993	1	< 0.1%
0.992	3	0.1%
0.991	1	< 0.1%
0.99	2	0.1%
0.989	5	0.2%
0.988	1	< 0.1%
0.986	3	0.1%

instrumentalness
Real number (ℝ_≥0)

ZEROS

Distinct	1107
Distinct (%)	54.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1332855286

Minimum	0
Maximum	0.976
Zeros	693
Zeros (%)	34.4%
Negative	0
Negative (%)	0.0%
Memory size	15.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	7.62 × 10^-5
Q3	0.054
95-th percentile	0.8522
Maximum	0.976
Range	0.976
Interquartile range (IQR)	0.054

Descriptive statistics

Standard deviation	0.2731621791
Coefficient of variation (CV)	2.049451144
Kurtosis	2.261179811
Mean	0.1332855286
Median Absolute Deviation (MAD)	7.62 × 10^-5
Skewness	1.952755178
Sum	268.8369112
Variance	0.07461757612
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	693	34.4%
0.897	5	0.2%
0.878	4	0.2%
0.425	3	0.1%
0.00128	3	0.1%
0.0107	3	0.1%
0.625	3	0.1%
1.54 × 10^-6	3	0.1%
0.698	3	0.1%
0.884	3	0.1%
Other values (1097)	1294	64.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	693	34.4%
1 × 10^-6	1	< 0.1%
1.01 × 10^-6	1	< 0.1%
1.03 × 10^-6	2	0.1%
1.04 × 10^-6	2	0.1%
1.07 × 10^-6	1	< 0.1%
1.11 × 10^-6	1	< 0.1%
1.12 × 10^-6	2	0.1%
1.16 × 10^-6	1	< 0.1%
1.22 × 10^-6	1	< 0.1%

Value	Count	Frequency (%)
0.976	1	< 0.1%
0.968	1	< 0.1%
0.964	1	< 0.1%
0.958	1	< 0.1%
0.957	1	< 0.1%
0.956	1	< 0.1%
0.955	1	< 0.1%
0.954	2	0.1%
0.952	1	< 0.1%
0.942	1	< 0.1%

key
Real number (ℝ_≥0)

ZEROS

Distinct	12
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.342588002

Minimum	0
Maximum	11
Zeros	216
Zeros (%)	10.7%
Negative	0
Negative (%)	0.0%
Memory size	15.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	6
Q3	9
95-th percentile	11
Maximum	11
Range	11
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	3.648240477
Coefficient of variation (CV)	0.6828601561
Kurtosis	-1.338827396
Mean	5.342588002
Median Absolute Deviation (MAD)	3
Skewness	-0.00935995938
Sum	10776
Variance	13.30965858
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	257	12.7%
0	216	10.7%
7	212	10.5%
9	191	9.5%
11	187	9.3%
2	184	9.1%
5	166	8.2%
6	159	7.9%
10	141	7.0%
8	136	6.7%
Other values (2)	168	8.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	216	10.7%
1	257	12.7%
2	184	9.1%
3	63	3.1%
4	105	5.2%
5	166	8.2%
6	159	7.9%
7	212	10.5%
8	136	6.7%
9	191	9.5%

Value	Count	Frequency (%)
11	187	9.3%
10	141	7.0%
9	191	9.5%
8	136	6.7%
7	212	10.5%
6	159	7.9%
5	166	8.2%
4	105	5.2%
3	63	3.1%
2	184	9.1%

liveness
Real number (ℝ_≥0)

Distinct	793
Distinct (%)	39.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1908440258

Minimum	0.0188
Maximum	0.969
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.9 KiB

Quantile statistics

Minimum	0.0188
5-th percentile	0.05674
Q1	0.0923
median	0.127
Q3	0.247
95-th percentile	0.538
Maximum	0.969
Range	0.9502
Interquartile range (IQR)	0.1547

Descriptive statistics

Standard deviation	0.155453165
Coefficient of variation (CV)	0.8145560983
Kurtosis	4.095643847
Mean	0.1908440258
Median Absolute Deviation (MAD)	0.0484
Skewness	1.952703491
Sum	384.9324
Variance	0.02416568651
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.101	22	1.1%
0.116	21	1.0%
0.111	20	1.0%
0.105	19	0.9%
0.114	19	0.9%
0.104	19	0.9%
0.122	19	0.9%
0.113	18	0.9%
0.109	18	0.9%
0.103	17	0.8%
Other values (783)	1825	90.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.0188	1	< 0.1%
0.0219	1	< 0.1%
0.022	1	< 0.1%
0.0234	1	< 0.1%
0.026	1	< 0.1%
0.0263	1	< 0.1%
0.0271	1	< 0.1%
0.0273	1	< 0.1%
0.0288	1	< 0.1%
0.0293	1	< 0.1%

Value	Count	Frequency (%)
0.969	1	< 0.1%
0.963	1	< 0.1%
0.953	1	< 0.1%
0.924	1	< 0.1%
0.91	1	< 0.1%
0.897	2	0.1%
0.887	1	< 0.1%
0.876	1	< 0.1%
0.873	1	< 0.1%
0.819	1	< 0.1%

loudness
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1808
Distinct (%)	89.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-7.085624194

Minimum	-33.097
Maximum	-0.307
Zeros	0
Zeros (%)	0.0%
Negative	2017
Negative (%)	100.0%
Memory size	15.9 KiB

Quantile statistics

Minimum	-33.097
5-th percentile	-14.1526
Q1	-8.394
median	-6.248
Q3	-4.746
95-th percentile	-3.0672
Maximum	-0.307
Range	32.79
Interquartile range (IQR)	3.648

Descriptive statistics

Standard deviation	3.761684275
Coefficient of variation (CV)	-0.5308896113
Kurtosis	7.908472702
Mean	-7.085624194
Median Absolute Deviation (MAD)	1.732
Skewness	-2.226556084
Sum	-14291.704
Variance	14.15026858
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-5.379	4	0.2%
-7.416	3	0.1%
-8.692	3	0.1%
-6.964	3	0.1%
-5.534	3	0.1%
-7.314	3	0.1%
-6.238	3	0.1%
-7.073	3	0.1%
-7.775	3	0.1%
-7.445	3	0.1%
Other values (1798)	1986	98.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-33.097	1	< 0.1%
-31.367	1	< 0.1%
-31.082	1	< 0.1%
-30.447	1	< 0.1%
-29.46	1	< 0.1%
-27.35	1	< 0.1%
-26.924	1	< 0.1%
-25.766	1	< 0.1%
-25.756	1	< 0.1%
-25.358	1	< 0.1%

Value	Count	Frequency (%)
-0.307	1	< 0.1%
-0.718	1	< 0.1%
-0.787	1	< 0.1%
-0.935	1	< 0.1%
-0.994	1	< 0.1%
-1.157	1	< 0.1%
-1.188	1	< 0.1%
-1.258	1	< 0.1%
-1.367	1	< 0.1%
-1.374	1	< 0.1%

mode
Categorical

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.9 KiB

1	1235
0	782

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
1	1235	61.2%
0	782	38.8%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	1235	61.2%
0	782	38.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

speechiness
Real number (ℝ_≥0)

Distinct	792
Distinct (%)	39.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.09266425384

Minimum	0.0231
Maximum	0.816
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.9 KiB

Quantile statistics

Minimum	0.0231
5-th percentile	0.0289
Q1	0.0375
median	0.0549
Q3	0.108
95-th percentile	0.31
Maximum	0.816
Range	0.7929
Interquartile range (IQR)	0.0705

Descriptive statistics

Standard deviation	0.08993146446
Coefficient of variation (CV)	0.9705086992
Kurtosis	6.260200685
Mean	0.09266425384
Median Absolute Deviation (MAD)	0.0218
Skewness	2.309580743
Sum	186.9038
Variance	0.0080876683
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.102	11	0.5%
0.0378	11	0.5%
0.054	10	0.5%
0.0334	9	0.4%
0.0345	9	0.4%
0.0335	9	0.4%
0.0353	9	0.4%
0.0363	9	0.4%
0.111	9	0.4%
0.0322	8	0.4%
Other values (782)	1923	95.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.0231	2	0.1%
0.0232	1	< 0.1%
0.0233	1	< 0.1%
0.0234	1	< 0.1%
0.0237	1	< 0.1%
0.0239	1	< 0.1%
0.0245	1	< 0.1%
0.0246	1	< 0.1%
0.0252	1	< 0.1%
0.0255	2	0.1%

Value	Count	Frequency (%)
0.816	1	< 0.1%
0.622	1	< 0.1%
0.548	1	< 0.1%
0.542	1	< 0.1%
0.488	1	< 0.1%
0.484	1	< 0.1%
0.482	1	< 0.1%
0.474	2	0.1%
0.455	1	< 0.1%
0.447	2	0.1%

tempo
Real number (ℝ_≥0)

Distinct	1919
Distinct (%)	95.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	121.6032717

Minimum	47.859
Maximum	219.331
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.9 KiB

Quantile statistics

Minimum	47.859
5-th percentile	80.9534
Q1	100.189
median	121.427
Q3	137.849
95-th percentile	171.9306
Maximum	219.331
Range	171.472
Interquartile range (IQR)	37.66

Descriptive statistics

Standard deviation	26.68560373
Coefficient of variation (CV)	0.2194480737
Kurtosis	0.04160001835
Mean	121.6032717
Median Absolute Deviation (MAD)	18.543
Skewness	0.4390583734
Sum	245273.799
Variance	712.1214465
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
99.995	3	0.1%
121.99	3	0.1%
119.999	3	0.1%
128.014	3	0.1%
128.004	3	0.1%
126.012	3	0.1%
123.966	3	0.1%
79.952	2	0.1%
97.967	2	0.1%
115.076	2	0.1%
Other values (1909)	1990	98.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
47.859	1	< 0.1%
59.385	1	< 0.1%
60.391	1	< 0.1%
60.483	1	< 0.1%
61.758	1	< 0.1%
63.637	1	< 0.1%
63.938	1	< 0.1%
64.97	1	< 0.1%
64.992	1	< 0.1%
65.003	1	< 0.1%

Value	Count	Frequency (%)
219.331	1	< 0.1%
209.686	1	< 0.1%
207.969	1	< 0.1%
203.822	1	< 0.1%
202.013	1	< 0.1%
200.749	1	< 0.1%
200.035	1	< 0.1%
199.988	1	< 0.1%
199.727	1	< 0.1%
199.519	1	< 0.1%

time_signature
Categorical

Distinct	4
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	15.9 KiB

4.0	1891
3.0	93
5.0	32
1.0	1

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	4.0
2nd row	4.0
3rd row	4.0
4th row	4.0
5th row	4.0

Common Values

Value	Count	Frequency (%)
4.0	1891	93.8%
3.0	93	4.6%
5.0	32	1.6%
1.0	1	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
4.0	1891	93.8%
3.0	93	4.6%
5.0	32	1.6%
1.0	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

valence
Real number (ℝ_≥0)

Distinct	853
Distinct (%)	42.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.4968150223

Minimum	0.0348
Maximum	0.992
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.9 KiB

Quantile statistics

Minimum	0.0348
5-th percentile	0.111
Q1	0.295
median	0.492
Q3	0.691
95-th percentile	0.9092
Maximum	0.992
Range	0.9572
Interquartile range (IQR)	0.396

Descriptive statistics

Standard deviation	0.2471954687
Coefficient of variation (CV)	0.4975603748
Kurtosis	-1.01058794
Mean	0.4968150223
Median Absolute Deviation (MAD)	0.198
Skewness	0.07838968431
Sum	1002.0759
Variance	0.06110559976
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.16	9	0.4%
0.372	9	0.4%
0.331	8	0.4%
0.769	8	0.4%
0.52	8	0.4%
0.354	7	0.3%
0.441	7	0.3%
0.668	7	0.3%
0.561	7	0.3%
0.308	7	0.3%
Other values (843)	1940	96.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.0348	1	< 0.1%
0.0359	1	< 0.1%
0.0373	2	0.1%
0.0378	1	< 0.1%
0.0384	1	< 0.1%
0.039	1	< 0.1%
0.0397	1	< 0.1%
0.0399	1	< 0.1%
0.044	1	< 0.1%
0.0451	2	0.1%

Value	Count	Frequency (%)
0.992	1	< 0.1%
0.975	1	< 0.1%
0.974	1	< 0.1%
0.973	2	0.1%
0.972	2	0.1%
0.971	1	< 0.1%
0.968	1	< 0.1%
0.967	4	0.2%
0.966	2	0.1%
0.965	3	0.1%

target
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.9 KiB

1	1020
0	997

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	1020	50.6%
0	997	49.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	1020	50.6%
0	997	49.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

song_title
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	1956
Distinct (%)	97.0%
Missing	0
Missing (%)	0.0%
Memory size	15.9 KiB

River	3
Jack	3
Mask Off	2
Be My Baby	2
Oblivion	2
Other values (1951)	2005

Length

Max length	120
Median length	14
Mean length	17.19137333
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1897 ?
Unique (%)	94.1%

Sample

1st row	Mask Off
2nd row	Redbone
3rd row	Xanny Family
4th row	Master Of None
5th row	Parallel Lines

Common Values

Value	Count	Frequency (%)
River	3	0.1%
Jack	3	0.1%
Mask Off	2	0.1%
Be My Baby	2	0.1%
Oblivion	2	0.1%
Obedear	2	0.1%
Swimming Pools (Drank) - Extended Version	2	0.1%
Pyramids	2	0.1%
1-800-273-8255	2	0.1%
Midnight City	2	0.1%
Other values (1946)	1995	98.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	293	4.4%
the	187	2.8%
you	141	2.1%
feat	127	1.9%
i	105	1.6%
me	87	1.3%
remix	83	1.2%
love	77	1.1%
of	75	1.1%
a	68	1.0%
Other values (2504)	5485	81.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

artist
Categorical

HIGH CARDINALITY

Distinct	1343
Distinct (%)	66.6%
Missing	0
Missing (%)	0.0%
Memory size	15.9 KiB

Drake	16
Rick Ross	13
Disclosure	12
WALK THE MOON	10
Backstreet Boys	10
Other values (1338)	1956

Length

Max length	82
Median length	11
Mean length	10.97372335
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1002 ?
Unique (%)	49.7%

Sample

1st row	Future
2nd row	Childish Gambino
3rd row	Future
4th row	Beach House
5th row	Junior Boys

Common Values

Value	Count	Frequency (%)
Drake	16	0.8%
Rick Ross	13	0.6%
Disclosure	12	0.6%
WALK THE MOON	10	0.5%
Backstreet Boys	10	0.5%
Crystal Castles	9	0.4%
FIDLAR	9	0.4%
Future	8	0.4%
Fall Out Boy	8	0.4%
Skrillex	8	0.4%
Other values (1333)	1914	94.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
the	145	3.8%
	51	1.3%
of	18	0.5%
brown	17	0.4%
young	17	0.4%
drake	16	0.4%
chris	15	0.4%
dj	14	0.4%
boys	14	0.4%
j	14	0.4%
Other values (1982)	3516	91.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	id	acousticness	danceability	duration_ms	energy	instrumentalness	key	liveness	loudness	mode	speechiness	tempo	time_signature	valence	target	song_title	artist
0	0	0.01020	0.833	204600	0.434	0.021900	2	0.1650	-8.795	1	0.4310	150.062	4.0	0.286	1	Mask Off	Future
1	1	0.19900	0.743	326933	0.359	0.006110	1	0.1370	-10.401	1	0.0794	160.083	4.0	0.588	1	Redbone	Childish Gambino
2	2	0.03440	0.838	185707	0.412	0.000234	2	0.1590	-7.148	1	0.2890	75.044	4.0	0.173	1	Xanny Family	Future
3	3	0.60400	0.494	199413	0.338	0.510000	5	0.0922	-15.236	1	0.0261	86.468	4.0	0.230	1	Master Of None	Beach House
4	4	0.18000	0.678	392893	0.561	0.512000	5	0.4390	-11.648	0	0.0694	174.004	4.0	0.904	1	Parallel Lines	Junior Boys
5	5	0.00479	0.804	251333	0.560	0.000000	8	0.1640	-6.682	1	0.1850	85.023	4.0	0.264	1	Sneakin’	Drake
6	6	0.01450	0.739	241400	0.472	0.000007	1	0.2070	-11.204	1	0.1560	80.030	4.0	0.308	1	Childs Play	Drake
7	7	0.02020	0.266	349667	0.348	0.664000	10	0.1600	-11.609	0	0.0371	144.154	4.0	0.393	1	Gyöngyhajú lány	Omega
8	8	0.04810	0.603	202853	0.944	0.000000	11	0.3420	-3.626	0	0.3470	130.035	4.0	0.398	1	I've Seen Footage	Death Grips
9	9	0.00208	0.836	226840	0.603	0.000000	7	0.5710	-7.792	1	0.2370	99.994	4.0	0.386	1	Digital Animal	Honey Claws

Last rows

	id	acousticness	danceability	duration_ms	energy	instrumentalness	key	liveness	loudness	mode	speechiness	tempo	time_signature	valence	song_title	artist
2007	2007	0.002170	0.639	296276	0.978	0.112000	11	0.0838	-2.376	1	0.0730	144.986	4.0	0.494	Let It Go - Scott Melker & Mister Gray Remix	NERVO
2008	2008	0.054100	0.646	160408	0.714	0.000000	0	0.1340	-6.511	1	0.0378	97.957	4.0	0.589	Call On Me - EDWYNN X TIKAL, Spirix Remix	Starley
2009	2009	0.004990	0.595	224000	0.837	0.035900	1	0.1010	-6.011	1	0.0696	149.964	4.0	0.331	Aamon	Kuuro
2010	2010	0.002310	0.624	206013	0.971	0.121000	6	0.2550	-0.935	0	0.0643	102.003	4.0	0.442	Hey Baby - Steve Aoki Remix	Dimitri Vegas & Like Mike
2011	2011	0.000586	0.528	245053	0.879	0.004890	6	0.0432	-5.891	0	0.1200	128.268	4.0	0.327	Brightside - Borgeous Remix	Icona Pop
2012	2012	0.001060	0.584	274404	0.932	0.002690	1	0.1290	-3.501	1	0.3330	74.976	4.0	0.211	Like A Bitch - Kill The Noise Remix	Kill The Noise
2013	2013	0.087700	0.894	182182	0.892	0.001670	1	0.0528	-2.663	1	0.1310	110.041	4.0	0.867	Candy	Dillon Francis
2014	2014	0.008570	0.637	207200	0.935	0.003990	0	0.2140	-2.467	1	0.1070	150.082	4.0	0.470	Habit - Dack Janiels & Wenzday Remix	Rain Man
2015	2015	0.001640	0.557	185600	0.992	0.677000	1	0.0913	-2.735	1	0.1330	150.011	4.0	0.623	First Contact	Twin Moons
2016	2016	0.002810	0.446	204520	0.915	0.000039	9	0.2180	-6.221	1	0.1410	190.013	4.0	0.402	I Wanna Get Better	Bleachers

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows